Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 100000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 11.4 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 1 |
| Categorical | 2 |
AOV is highly overall correlated with ROAS and 1 other fields | High correlation |
Ad_CPC is highly overall correlated with Ad_Spend | High correlation |
Ad_CTR is highly overall correlated with Ad_Spend | High correlation |
Ad_Spend is highly overall correlated with Ad_CPC and 2 other fields | High correlation |
Clicks is highly overall correlated with Conversion_Rate | High correlation |
Conversion_Rate is highly overall correlated with Clicks and 1 other fields | High correlation |
Impressions is highly overall correlated with Conversion_Rate | High correlation |
ROAS is highly overall correlated with AOV and 2 other fields | High correlation |
Revenue is highly overall correlated with AOV and 1 other fields | High correlation |
Discount_Applied has 1685 (1.7%) zeros | Zeros |
Clicks has 1999 (2.0%) zeros | Zeros |
Conversion_Rate has 3621 (3.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-08 22:29:29.751739 |
|---|---|
| Analysis finished | 2024-12-08 22:30:01.453078 |
| Duration | 31.7 seconds |
| Software version | ydata-profiling vv4.10.0 |
| Download configuration | config.json |
Product_ID
Real number (ℝ)
| Distinct | 1000 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 499.51473 |
| Minimum | 0 |
|---|---|
| Maximum | 999 |
| Zeros | 110 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50 |
| Q1 | 250 |
| median | 500 |
| Q3 | 749 |
| 95-th percentile | 950 |
| Maximum | 999 |
| Range | 999 |
| Interquartile range (IQR) | 499 |
Descriptive statistics
| Standard deviation | 288.77872 |
|---|---|
| Coefficient of variation (CV) | 0.57811853 |
| Kurtosis | -1.2002857 |
| Mean | 499.51473 |
| Median Absolute Deviation (MAD) | 250 |
| Skewness | -3.3552055 × 10-5 |
| Sum | 49951473 |
| Variance | 83393.151 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 521 | 137 | 0.1% |
| 130 | 135 | 0.1% |
| 933 | 133 | 0.1% |
| 829 | 132 | 0.1% |
| 719 | 132 | 0.1% |
| 835 | 129 | 0.1% |
| 111 | 127 | 0.1% |
| 276 | 127 | 0.1% |
| 1 | 126 | 0.1% |
| 606 | 126 | 0.1% |
| Other values (990) | 98696 |
| Value | Count | Frequency (%) |
| 0 | 110 | |
| 1 | 126 | |
| 2 | 106 | |
| 3 | 89 | |
| 4 | 102 | |
| 5 | 101 | |
| 6 | 85 | |
| 7 | 92 | |
| 8 | 109 | |
| 9 | 86 |
| Value | Count | Frequency (%) |
| 999 | 101 | |
| 998 | 116 | |
| 997 | 101 | |
| 996 | 89 | |
| 995 | 105 | |
| 994 | 107 | |
| 993 | 95 | |
| 992 | 89 | |
| 991 | 87 | |
| 990 | 114 |
Transaction_Date
Date
| Distinct | 366 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| Minimum | 2023-12-07 00:00:00 |
|---|---|
| Maximum | 2024-12-06 00:00:00 |
Units_Sold
Real number (ℝ)
| Distinct | 344 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 128.32858 |
| Minimum | 51 |
|---|---|
| Maximum | 716 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 51 |
|---|---|
| 5-th percentile | 61 |
| Q1 | 84 |
| median | 127 |
| Q3 | 166 |
| 95-th percentile | 208 |
| Maximum | 716 |
| Range | 665 |
| Interquartile range (IQR) | 82 |
Descriptive statistics
| Standard deviation | 49.679873 |
|---|---|
| Coefficient of variation (CV) | 0.38713023 |
| Kurtosis | 4.4677607 |
| Mean | 128.32858 |
| Median Absolute Deviation (MAD) | 41 |
| Skewness | 0.86305924 |
| Sum | 12832858 |
| Variance | 2468.0897 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 72 | 1133 | 1.1% |
| 68 | 1102 | 1.1% |
| 79 | 1066 | 1.1% |
| 70 | 1062 | 1.1% |
| 165 | 1046 | 1.0% |
| 62 | 1026 | 1.0% |
| 80 | 1020 | 1.0% |
| 77 | 1019 | 1.0% |
| 64 | 1009 | 1.0% |
| 75 | 989 | 1.0% |
| Other values (334) | 89528 |
| Value | Count | Frequency (%) |
| 51 | 106 | 0.1% |
| 52 | 158 | 0.2% |
| 53 | 284 | 0.3% |
| 54 | 327 | |
| 55 | 307 | |
| 56 | 517 | |
| 57 | 495 | |
| 58 | 744 | |
| 59 | 688 | |
| 60 | 700 |
| Value | Count | Frequency (%) |
| 716 | 1 | < 0.1% |
| 706 | 1 | < 0.1% |
| 702 | 1 | < 0.1% |
| 692 | 1 | < 0.1% |
| 677 | 1 | < 0.1% |
| 663 | 1 | < 0.1% |
| 659 | 1 | < 0.1% |
| 656 | 1 | < 0.1% |
| 639 | 4 | |
| 636 | 1 | < 0.1% |
Discount_Applied
Real number (ℝ)
ZEROS 
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1498715 |
| Minimum | 0 |
|---|---|
| Maximum | 0.3 |
| Zeros | 1685 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.01 |
| Q1 | 0.07 |
| median | 0.15 |
| Q3 | 0.22 |
| 95-th percentile | 0.29 |
| Maximum | 0.3 |
| Range | 0.3 |
| Interquartile range (IQR) | 0.15 |
Descriptive statistics
| Standard deviation | 0.086691785 |
|---|---|
| Coefficient of variation (CV) | 0.57844077 |
| Kurtosis | -1.1911827 |
| Mean | 0.1498715 |
| Median Absolute Deviation (MAD) | 0.07 |
| Skewness | -0.00016104881 |
| Sum | 14987.15 |
| Variance | 0.0075154656 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.04 | 3440 | 3.4% |
| 0.15 | 3434 | 3.4% |
| 0.23 | 3411 | 3.4% |
| 0.17 | 3403 | 3.4% |
| 0.03 | 3395 | 3.4% |
| 0.1 | 3388 | 3.4% |
| 0.29 | 3381 | 3.4% |
| 0.18 | 3376 | 3.4% |
| 0.19 | 3374 | 3.4% |
| 0.27 | 3371 | 3.4% |
| Other values (21) | 66027 |
| Value | Count | Frequency (%) |
| 0 | 1685 | |
| 0.01 | 3358 | |
| 0.02 | 3305 | |
| 0.03 | 3395 | |
| 0.04 | 3440 | |
| 0.05 | 3259 | |
| 0.06 | 3348 | |
| 0.07 | 3234 | |
| 0.08 | 3292 | |
| 0.09 | 3289 |
| Value | Count | Frequency (%) |
| 0.3 | 1683 | |
| 0.29 | 3381 | |
| 0.28 | 3226 | |
| 0.27 | 3371 | |
| 0.26 | 3286 | |
| 0.25 | 3211 | |
| 0.24 | 3368 | |
| 0.23 | 3411 | |
| 0.22 | 3337 | |
| 0.21 | 3302 |
Revenue
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 51950 |
|---|---|
| Distinct (%) | 51.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 553.11081 |
| Minimum | 7.65 |
|---|---|
| Maximum | 5704.18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 7.65 |
|---|---|
| 5-th percentile | 58.18 |
| Q1 | 221.26 |
| median | 428.155 |
| Q3 | 805.865 |
| 95-th percentile | 1394.8115 |
| Maximum | 5704.18 |
| Range | 5696.53 |
| Interquartile range (IQR) | 584.605 |
Descriptive statistics
| Standard deviation | 428.36629 |
|---|---|
| Coefficient of variation (CV) | 0.77446741 |
| Kurtosis | 2.5510045 |
| Mean | 553.11081 |
| Median Absolute Deviation (MAD) | 264.82 |
| Skewness | 1.1713089 |
| Sum | 55311081 |
| Variance | 183497.68 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1078.59 | 13 | < 0.1% |
| 96.16 | 12 | < 0.1% |
| 89.91 | 11 | < 0.1% |
| 173.61 | 11 | < 0.1% |
| 65.5 | 11 | < 0.1% |
| 492.92 | 10 | < 0.1% |
| 346.74 | 10 | < 0.1% |
| 331.66 | 10 | < 0.1% |
| 155.66 | 10 | < 0.1% |
| 298.08 | 10 | < 0.1% |
| Other values (51940) | 99892 |
| Value | Count | Frequency (%) |
| 7.65 | 1 | < 0.1% |
| 8.19 | 2 | < 0.1% |
| 8.3 | 3 | |
| 8.39 | 1 | < 0.1% |
| 8.4 | 1 | < 0.1% |
| 8.41 | 2 | < 0.1% |
| 8.52 | 5 | |
| 8.53 | 1 | < 0.1% |
| 8.63 | 1 | < 0.1% |
| 8.64 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5704.18 | 1 | |
| 5433.46 | 1 | |
| 5397.12 | 1 | |
| 4980.53 | 1 | |
| 4875.95 | 1 | |
| 4864.31 | 1 | |
| 4629.08 | 1 | |
| 4574.36 | 1 | |
| 4571.41 | 1 | |
| 4559.46 | 1 |
Clicks
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 50 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.53917 |
| Minimum | 0 |
|---|---|
| Maximum | 49 |
| Zeros | 1999 |
| Zeros (%) | 2.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 12 |
| median | 25 |
| Q3 | 37 |
| 95-th percentile | 47 |
| Maximum | 49 |
| Range | 49 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 14.412477 |
|---|---|
| Coefficient of variation (CV) | 0.58732535 |
| Kurtosis | -1.2001615 |
| Mean | 24.53917 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.0049981154 |
| Sum | 2453917 |
| Variance | 207.71948 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37 | 2091 | 2.1% |
| 42 | 2083 | 2.1% |
| 39 | 2066 | 2.1% |
| 36 | 2063 | 2.1% |
| 17 | 2060 | 2.1% |
| 11 | 2059 | 2.1% |
| 27 | 2057 | 2.1% |
| 21 | 2052 | 2.1% |
| 33 | 2049 | 2.0% |
| 46 | 2030 | 2.0% |
| Other values (40) | 79390 |
| Value | Count | Frequency (%) |
| 0 | 1999 | |
| 1 | 1990 | |
| 2 | 1959 | |
| 3 | 1923 | |
| 4 | 1984 | |
| 5 | 1992 | |
| 6 | 2028 | |
| 7 | 2015 | |
| 8 | 2012 | |
| 9 | 2006 |
| Value | Count | Frequency (%) |
| 49 | 1980 | |
| 48 | 1958 | |
| 47 | 2016 | |
| 46 | 2030 | |
| 45 | 2026 | |
| 44 | 2001 | |
| 43 | 1939 | |
| 42 | 2083 | |
| 41 | 1900 | |
| 40 | 1944 |
Impressions
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 490 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 254.53906 |
| Minimum | 10 |
|---|---|
| Maximum | 499 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 34 |
| Q1 | 132 |
| median | 254 |
| Q3 | 377 |
| 95-th percentile | 475 |
| Maximum | 499 |
| Range | 489 |
| Interquartile range (IQR) | 245 |
Descriptive statistics
| Standard deviation | 141.46661 |
|---|---|
| Coefficient of variation (CV) | 0.55577563 |
| Kurtosis | -1.2011747 |
| Mean | 254.53906 |
| Median Absolute Deviation (MAD) | 122 |
| Skewness | 8.50296 × 10-5 |
| Sum | 25453906 |
| Variance | 20012.801 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 240 | 0.2% |
| 410 | 239 | 0.2% |
| 376 | 238 | 0.2% |
| 412 | 237 | 0.2% |
| 212 | 237 | 0.2% |
| 447 | 237 | 0.2% |
| 196 | 236 | 0.2% |
| 44 | 236 | 0.2% |
| 133 | 235 | 0.2% |
| 156 | 235 | 0.2% |
| Other values (480) | 97630 |
| Value | Count | Frequency (%) |
| 10 | 208 | |
| 11 | 175 | |
| 12 | 198 | |
| 13 | 201 | |
| 14 | 207 | |
| 15 | 207 | |
| 16 | 187 | |
| 17 | 184 | |
| 18 | 191 | |
| 19 | 209 |
| Value | Count | Frequency (%) |
| 499 | 209 | |
| 498 | 201 | |
| 497 | 224 | |
| 496 | 221 | |
| 495 | 183 | |
| 494 | 208 | |
| 493 | 214 | |
| 492 | 188 | |
| 491 | 201 | |
| 490 | 198 |
Conversion_Rate
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1981378 |
| Minimum | 0 |
|---|---|
| Maximum | 4.9 |
| Zeros | 3621 |
| Zeros (%) | 3.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.01 |
| Q1 | 0.05 |
| median | 0.1 |
| Q3 | 0.19 |
| 95-th percentile | 0.74 |
| Maximum | 4.9 |
| Range | 4.9 |
| Interquartile range (IQR) | 0.14 |
Descriptive statistics
| Standard deviation | 0.36118743 |
|---|---|
| Coefficient of variation (CV) | 1.8229103 |
| Kurtosis | 37.730717 |
| Mean | 0.1981378 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | 5.3076844 |
| Sum | 19813.78 |
| Variance | 0.13045636 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.09 | 5196 | 5.2% |
| 0.08 | 5145 | 5.1% |
| 0.07 | 5135 | 5.1% |
| 0.05 | 5121 | 5.1% |
| 0.06 | 5095 | 5.1% |
| 0.04 | 5081 | 5.1% |
| 0.02 | 5062 | 5.1% |
| 0.03 | 5035 | 5.0% |
| 0.1 | 4959 | 5.0% |
| 0.01 | 4901 | 4.9% |
| Other values (323) | 49270 |
| Value | Count | Frequency (%) |
| 0 | 3621 | |
| 0.01 | 4901 | |
| 0.02 | 5062 | |
| 0.03 | 5035 | |
| 0.04 | 5081 | |
| 0.05 | 5121 | |
| 0.06 | 5095 | |
| 0.07 | 5135 | |
| 0.08 | 5145 | |
| 0.09 | 5196 |
| Value | Count | Frequency (%) |
| 4.9 | 1 | < 0.1% |
| 4.8 | 5 | |
| 4.7 | 4 | |
| 4.6 | 4 | |
| 4.5 | 5 | |
| 4.45 | 3 | |
| 4.4 | 1 | < 0.1% |
| 4.36 | 3 | |
| 4.3 | 1 | < 0.1% |
| 4.27 | 5 |
Category
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| 2 | |
|---|---|
| 4 | |
| 3 | |
| 1 | |
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 100000 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 3 |
| 3rd row | 4 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 21533 | |
| 4 | 20764 | |
| 3 | 19419 | |
| 1 | 19278 | |
| 0 | 19006 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 21533 | |
| 4 | 20764 | |
| 3 | 19419 | |
| 1 | 19278 | |
| 0 | 19006 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 21533 | |
| 4 | 20764 | |
| 3 | 19419 | |
| 1 | 19278 | |
| 0 | 19006 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 21533 | |
| 4 | 20764 | |
| 3 | 19419 | |
| 1 | 19278 | |
| 0 | 19006 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 21533 | |
| 4 | 20764 | |
| 3 | 19419 | |
| 1 | 19278 | |
| 0 | 19006 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 21533 | |
| 4 | 20764 | |
| 3 | 19419 | |
| 1 | 19278 | |
| 0 | 19006 |
Region
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 100000 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 33472 | |
| 1 | 33265 | |
| 2 | 33263 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 33472 | |
| 1 | 33265 | |
| 2 | 33263 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 33472 | |
| 1 | 33265 | |
| 2 | 33263 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 33472 | |
| 1 | 33265 | |
| 2 | 33263 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 33472 | |
| 1 | 33265 | |
| 2 | 33263 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 33472 | |
| 1 | 33265 | |
| 2 | 33263 |
Ad_CTR
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1901 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10498773 |
| Minimum | 0.01 |
|---|---|
| Maximum | 0.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.0196 |
| Q1 | 0.0575 |
| median | 0.1052 |
| Q3 | 0.1523 |
| 95-th percentile | 0.1907 |
| Maximum | 0.2 |
| Range | 0.19 |
| Interquartile range (IQR) | 0.0948 |
Descriptive statistics
| Standard deviation | 0.054806269 |
|---|---|
| Coefficient of variation (CV) | 0.52202548 |
| Kurtosis | -1.1941851 |
| Mean | 0.10498773 |
| Median Absolute Deviation (MAD) | 0.0474 |
| Skewness | 0.0028388654 |
| Sum | 10498.773 |
| Variance | 0.0030037271 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.08 | 81 | 0.1% |
| 0.1264 | 74 | 0.1% |
| 0.1267 | 74 | 0.1% |
| 0.1646 | 73 | 0.1% |
| 0.0793 | 73 | 0.1% |
| 0.0155 | 73 | 0.1% |
| 0.1219 | 73 | 0.1% |
| 0.0603 | 73 | 0.1% |
| 0.13 | 73 | 0.1% |
| 0.0339 | 73 | 0.1% |
| Other values (1891) | 99260 |
| Value | Count | Frequency (%) |
| 0.01 | 25 | |
| 0.0101 | 40 | |
| 0.0102 | 54 | |
| 0.0103 | 57 | |
| 0.0104 | 57 | |
| 0.0105 | 57 | |
| 0.0106 | 59 | |
| 0.0107 | 48 | |
| 0.0108 | 57 | |
| 0.0109 | 58 |
| Value | Count | Frequency (%) |
| 0.2 | 29 | |
| 0.1999 | 50 | |
| 0.1998 | 57 | |
| 0.1997 | 53 | |
| 0.1996 | 60 | |
| 0.1995 | 55 | |
| 0.1994 | 43 | |
| 0.1993 | 55 | |
| 0.1992 | 56 | |
| 0.1991 | 66 |
Ad_CPC
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 191 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0512502 |
| Minimum | 0.1 |
|---|---|
| Maximum | 2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.19 |
| Q1 | 0.58 |
| median | 1.05 |
| Q3 | 1.53 |
| 95-th percentile | 1.91 |
| Maximum | 2 |
| Range | 1.9 |
| Interquartile range (IQR) | 0.95 |
Descriptive statistics
| Standard deviation | 0.54925209 |
|---|---|
| Coefficient of variation (CV) | 0.52247514 |
| Kurtosis | -1.203856 |
| Mean | 1.0512502 |
| Median Absolute Deviation (MAD) | 0.48 |
| Skewness | -0.0025045966 |
| Sum | 105125.02 |
| Variance | 0.30167786 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.66 | 580 | 0.6% |
| 0.67 | 577 | 0.6% |
| 1.97 | 575 | 0.6% |
| 1.66 | 575 | 0.6% |
| 0.76 | 571 | 0.6% |
| 1.37 | 570 | 0.6% |
| 1.96 | 568 | 0.6% |
| 0.3 | 566 | 0.6% |
| 1.69 | 566 | 0.6% |
| 0.16 | 564 | 0.6% |
| Other values (181) | 94288 |
| Value | Count | Frequency (%) |
| 0.1 | 268 | |
| 0.11 | 503 | |
| 0.12 | 507 | |
| 0.13 | 521 | |
| 0.14 | 553 | |
| 0.15 | 513 | |
| 0.16 | 564 | |
| 0.17 | 548 | |
| 0.18 | 516 | |
| 0.19 | 529 |
| Value | Count | Frequency (%) |
| 2 | 276 | |
| 1.99 | 522 | |
| 1.98 | 540 | |
| 1.97 | 575 | |
| 1.96 | 568 | |
| 1.95 | 495 | |
| 1.94 | 507 | |
| 1.93 | 494 | |
| 1.92 | 518 | |
| 1.91 | 546 |
Ad_Spend
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 27756 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.47724 |
| Minimum | 1.05 |
|---|---|
| Maximum | 399.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 1.05 |
|---|---|
| 5-th percentile | 11.68 |
| Q1 | 38.61 |
| median | 87.24 |
| Q3 | 164.22 |
| 95-th percentile | 286.9505 |
| Maximum | 399.6 |
| Range | 398.55 |
| Interquartile range (IQR) | 125.61 |
Descriptive statistics
| Standard deviation | 87.015846 |
|---|---|
| Coefficient of variation (CV) | 0.78763595 |
| Kurtosis | 0.040110794 |
| Mean | 110.47724 |
| Median Absolute Deviation (MAD) | 56.57 |
| Skewness | 0.91088071 |
| Sum | 11047724 |
| Variance | 7571.7574 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20.9 | 23 | < 0.1% |
| 26.4 | 22 | < 0.1% |
| 31.62 | 22 | < 0.1% |
| 57.72 | 22 | < 0.1% |
| 22.18 | 22 | < 0.1% |
| 14.76 | 22 | < 0.1% |
| 34.1 | 21 | < 0.1% |
| 31.46 | 21 | < 0.1% |
| 19.55 | 21 | < 0.1% |
| 27.72 | 21 | < 0.1% |
| Other values (27746) | 99783 |
| Value | Count | Frequency (%) |
| 1.05 | 1 | |
| 1.11 | 1 | |
| 1.12 | 1 | |
| 1.13 | 1 | |
| 1.16 | 1 | |
| 1.21 | 1 | |
| 1.22 | 1 | |
| 1.23 | 1 | |
| 1.24 | 1 | |
| 1.25 | 1 |
| Value | Count | Frequency (%) |
| 399.6 | 1 | < 0.1% |
| 397.8 | 1 | < 0.1% |
| 397.4 | 2 | |
| 396.41 | 1 | < 0.1% |
| 395.6 | 3 | |
| 395.21 | 2 | |
| 395.2 | 1 | < 0.1% |
| 394.42 | 1 | < 0.1% |
| 394 | 1 | < 0.1% |
| 393.82 | 1 | < 0.1% |
AOV
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 98494 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0124039 |
| Minimum | 0.04076555 |
|---|---|
| Maximum | 35.787407 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0.04076555 |
|---|---|
| 5-th percentile | 0.45048427 |
| Q1 | 1.7163424 |
| median | 3.6395381 |
| Q3 | 6.8815433 |
| 95-th percentile | 14.503062 |
| Maximum | 35.787407 |
| Range | 35.746642 |
| Interquartile range (IQR) | 5.1652008 |
Descriptive statistics
| Standard deviation | 4.5725213 |
|---|---|
| Coefficient of variation (CV) | 0.91224119 |
| Kurtosis | 3.4663514 |
| Mean | 5.0124039 |
| Median Absolute Deviation (MAD) | 2.2828193 |
| Skewness | 1.6956415 |
| Sum | 501240.39 |
| Variance | 20.907951 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.2 | 4 | < 0.1% |
| 4.345 | 4 | < 0.1% |
| 5.55 | 4 | < 0.1% |
| 4.97 | 4 | < 0.1% |
| 4.18 | 4 | < 0.1% |
| 2.03 | 4 | < 0.1% |
| 2.44 | 4 | < 0.1% |
| 0.76 | 4 | < 0.1% |
| 0.47 | 4 | < 0.1% |
| 0.7614285714 | 4 | < 0.1% |
| Other values (98484) | 99960 |
| Value | Count | Frequency (%) |
| 0.04076555024 | 1 | |
| 0.04401960784 | 1 | |
| 0.04460784314 | 1 | |
| 0.04507936508 | 1 | |
| 0.04656565657 | 1 | |
| 0.04722222222 | 1 | |
| 0.04848039216 | 1 | |
| 0.04904255319 | 1 | |
| 0.04961206897 | 1 | |
| 0.05024509804 | 1 |
| Value | Count | Frequency (%) |
| 35.78740741 | 1 | |
| 35.28363636 | 1 | |
| 35.12611111 | 1 | |
| 34.79581818 | 1 | |
| 34.36407407 | 1 | |
| 33.7559322 | 1 | |
| 33.59107143 | 1 | |
| 33.45254237 | 1 | |
| 33.00084746 | 1 | |
| 32.71035714 | 1 |
ROAS
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 99977 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.66115 |
| Minimum | 0.024971847 |
|---|---|
| Maximum | 1145.0743 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0.024971847 |
|---|---|
| 5-th percentile | 0.50670056 |
| Q1 | 2.0753293 |
| median | 5.0818523 |
| Q3 | 12.756096 |
| 95-th percentile | 52.11139 |
| Maximum | 1145.0743 |
| Range | 1145.0494 |
| Interquartile range (IQR) | 10.680767 |
Descriptive statistics
| Standard deviation | 31.564643 |
|---|---|
| Coefficient of variation (CV) | 2.3105407 |
| Kurtosis | 172.80231 |
| Mean | 13.66115 |
| Median Absolute Deviation (MAD) | 3.743635 |
| Skewness | 9.8289965 |
| Sum | 1366115 |
| Variance | 996.32668 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.27862503 | 2 | < 0.1% |
| 5.215155152 | 2 | < 0.1% |
| 13.27424749 | 2 | < 0.1% |
| 3.079710145 | 2 | < 0.1% |
| 18.39308579 | 2 | < 0.1% |
| 12.84504792 | 2 | < 0.1% |
| 29 | 2 | < 0.1% |
| 15.61111111 | 2 | < 0.1% |
| 2.928571429 | 2 | < 0.1% |
| 5.666666667 | 2 | < 0.1% |
| Other values (99967) | 99980 |
| Value | Count | Frequency (%) |
| 0.02497184685 | 1 | |
| 0.02847441313 | 1 | |
| 0.03099730458 | 1 | |
| 0.03184142853 | 1 | |
| 0.0321845175 | 1 | |
| 0.03228743522 | 1 | |
| 0.03248444049 | 1 | |
| 0.03254488216 | 1 | |
| 0.03258224072 | 1 | |
| 0.03304440592 | 1 |
| Value | Count | Frequency (%) |
| 1145.074324 | 1 | |
| 1115.720588 | 1 | |
| 1061.974138 | 1 | |
| 1037.351351 | 1 | |
| 949.5136986 | 1 | |
| 894.056338 | 1 | |
| 830.9381443 | 1 | |
| 763.4064039 | 1 | |
| 756.0785714 | 1 | |
| 742.9907063 | 1 |
| AOV | Ad_CPC | Ad_CTR | Ad_Spend | Category | Clicks | Conversion_Rate | Discount_Applied | Impressions | Product_ID | ROAS | Region | Revenue | Units_Sold | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AOV | 1.000 | 0.003 | 0.006 | 0.007 | 0.053 | 0.005 | 0.001 | -0.097 | 0.005 | -0.001 | 0.611 | 0.078 | 0.908 | -0.381 |
| Ad_CPC | 0.003 | 1.000 | 0.004 | 0.679 | 0.004 | -0.005 | -0.007 | 0.003 | 0.006 | -0.003 | -0.478 | 0.000 | 0.002 | -0.003 |
| Ad_CTR | 0.006 | 0.004 | 1.000 | 0.679 | 0.003 | 0.004 | 0.005 | -0.003 | -0.005 | 0.004 | -0.474 | 0.000 | 0.007 | 0.000 |
| Ad_Spend | 0.007 | 0.679 | 0.679 | 1.000 | 0.003 | -0.001 | -0.001 | -0.001 | 0.001 | 0.001 | -0.700 | 0.006 | 0.006 | -0.003 |
| Category | 0.053 | 0.004 | 0.003 | 0.003 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.093 | 0.004 | 0.000 | 0.025 | 0.079 |
| Clicks | 0.005 | -0.005 | 0.004 | -0.001 | 0.000 | 1.000 | 0.697 | -0.003 | 0.002 | -0.001 | 0.006 | 0.000 | 0.007 | 0.004 |
| Conversion_Rate | 0.001 | -0.007 | 0.005 | -0.001 | 0.000 | 0.697 | 1.000 | -0.002 | -0.635 | -0.004 | 0.003 | 0.000 | 0.002 | 0.001 |
| Discount_Applied | -0.097 | 0.003 | -0.003 | -0.001 | 0.000 | -0.003 | -0.002 | 1.000 | -0.004 | -0.002 | -0.073 | 0.000 | -0.110 | -0.000 |
| Impressions | 0.005 | 0.006 | -0.005 | 0.001 | 0.000 | 0.002 | -0.635 | -0.004 | 1.000 | 0.003 | 0.003 | 0.009 | 0.005 | 0.001 |
| Product_ID | -0.001 | -0.003 | 0.004 | 0.001 | 0.093 | -0.001 | -0.004 | -0.002 | 0.003 | 1.000 | -0.004 | 0.000 | -0.001 | -0.002 |
| ROAS | 0.611 | -0.478 | -0.474 | -0.700 | 0.004 | 0.006 | 0.003 | -0.073 | 0.003 | -0.004 | 1.000 | 0.007 | 0.669 | 0.010 |
| Region | 0.078 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | 0.000 | 0.009 | 0.000 | 0.007 | 1.000 | 0.006 | 0.277 |
| Revenue | 0.908 | 0.002 | 0.007 | 0.006 | 0.025 | 0.007 | 0.002 | -0.110 | 0.005 | -0.001 | 0.669 | 0.006 | 1.000 | 0.010 |
| Units_Sold | -0.381 | -0.003 | 0.000 | -0.003 | 0.079 | 0.004 | 0.001 | -0.000 | 0.001 | -0.002 | 0.010 | 0.277 | 0.010 | 1.000 |
| Product_ID | Transaction_Date | Units_Sold | Discount_Applied | Revenue | Clicks | Impressions | Conversion_Rate | Category | Region | Ad_CTR | Ad_CPC | Ad_Spend | AOV | ROAS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 140 | 2024-10-06 | 134 | 0.14 | 305.54 | 11 | 65 | 0.17 | 2 | 1 | 0.0180 | 0.55 | 9.90 | 2.280149 | 30.862626 |
| 1 | 539 | 2024-10-29 | 109 | 0.30 | 1102.19 | 15 | 201 | 0.07 | 3 | 0 | 0.1589 | 0.40 | 63.56 | 10.111835 | 17.340938 |
| 2 | 306 | 2024-04-04 | 116 | 0.04 | 471.29 | 16 | 199 | 0.08 | 4 | 0 | 0.0596 | 1.50 | 89.40 | 4.062845 | 5.271700 |
| 3 | 136 | 2024-08-25 | 125 | 0.20 | 980.26 | 12 | 355 | 0.03 | 1 | 1 | 0.0444 | 0.44 | 19.54 | 7.842080 | 50.166837 |
| 4 | 288 | 2024-05-05 | 132 | 0.07 | 803.76 | 44 | 355 | 0.12 | 0 | 2 | 0.1270 | 0.53 | 67.31 | 6.089091 | 11.941168 |
| 5 | 38 | 2024-09-22 | 160 | 0.25 | 69.37 | 4 | 73 | 0.05 | 2 | 2 | 0.0153 | 1.13 | 17.29 | 0.433563 | 4.012146 |
| 6 | 567 | 2023-12-08 | 145 | 0.17 | 121.56 | 25 | 110 | 0.23 | 1 | 2 | 0.0889 | 1.97 | 175.13 | 0.838345 | 0.694113 |
| 7 | 546 | 2024-04-30 | 121 | 0.28 | 208.64 | 1 | 208 | 0.00 | 2 | 0 | 0.0133 | 1.22 | 16.23 | 1.724298 | 12.855206 |
| 8 | 787 | 2024-04-10 | 152 | 0.20 | 757.34 | 27 | 73 | 0.37 | 4 | 2 | 0.1562 | 1.55 | 242.11 | 4.982500 | 3.128082 |
| 9 | 64 | 2024-11-24 | 152 | 0.17 | 163.74 | 10 | 299 | 0.03 | 4 | 2 | 0.0728 | 0.75 | 54.60 | 1.077237 | 2.998901 |
| Product_ID | Transaction_Date | Units_Sold | Discount_Applied | Revenue | Clicks | Impressions | Conversion_Rate | Category | Region | Ad_CTR | Ad_CPC | Ad_Spend | AOV | ROAS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99990 | 163 | 2024-07-19 | 163 | 0.25 | 664.66 | 46 | 407 | 0.11 | 2 | 0 | 0.0296 | 1.84 | 54.46 | 4.077669 | 12.204554 |
| 99991 | 800 | 2024-11-05 | 182 | 0.10 | 777.02 | 31 | 196 | 0.16 | 2 | 1 | 0.1607 | 0.67 | 107.67 | 4.269341 | 7.216681 |
| 99992 | 984 | 2024-06-23 | 148 | 0.08 | 373.52 | 8 | 456 | 0.02 | 0 | 1 | 0.0685 | 1.70 | 116.45 | 2.523784 | 3.207557 |
| 99993 | 582 | 2024-01-21 | 163 | 0.06 | 213.25 | 3 | 340 | 0.01 | 1 | 1 | 0.0135 | 0.45 | 6.07 | 1.308282 | 35.131796 |
| 99994 | 247 | 2024-01-07 | 175 | 0.02 | 142.16 | 9 | 461 | 0.02 | 0 | 2 | 0.0363 | 1.11 | 40.29 | 0.812343 | 3.528419 |
| 99995 | 415 | 2024-04-21 | 179 | 0.11 | 255.11 | 41 | 428 | 0.10 | 2 | 1 | 0.1073 | 1.48 | 158.80 | 1.425196 | 1.606486 |
| 99996 | 764 | 2024-09-17 | 178 | 0.12 | 1302.60 | 6 | 363 | 0.02 | 0 | 2 | 0.1164 | 0.36 | 41.90 | 7.317978 | 31.088305 |
| 99997 | 718 | 2024-10-23 | 212 | 0.26 | 491.36 | 5 | 419 | 0.01 | 2 | 2 | 0.1235 | 0.20 | 24.70 | 2.317736 | 19.893117 |
| 99998 | 323 | 2024-01-03 | 180 | 0.09 | 598.91 | 41 | 12 | 3.42 | 2 | 1 | 0.1566 | 0.96 | 150.34 | 3.327278 | 3.983704 |
| 99999 | 139 | 2024-07-12 | 157 | 0.20 | 208.27 | 34 | 334 | 0.10 | 4 | 0 | 0.0926 | 0.61 | 56.49 | 1.326561 | 3.686847 |